package com.hubu.jwxt.beans;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.util.List;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Student {
    /*
    CREATE TABLE `student`  (
  `s_id` int(5) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `s_num` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '学生学号',
  `s_pwd` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '学生密码',
  `s_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '学生姓名',
  `s_class` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '学生所属的班级',
  `s_sex` enum('男','女') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '学生性别，枚举类型',
  `s_age` int(5) NOT NULL COMMENT '学生年龄',
  `s_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '学生电话',
  `s_email` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '学生邮件',
  PRIMARY KEY (`s_id`) USING BTREE,
  INDEX `s_num`(`s_num`) USING BTREE,
  INDEX `s_class`(`s_class`) USING BTREE,
  CONSTRAINT `s_class` FOREIGN KEY (`s_class`) REFERENCES `class` (`class_name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;
     */

    private int s_id;
    private String s_num;
    private String s_pwd;
    private String s_name;
    private String s_class;
    private Enum.Sex s_sex;
    private int s_age;
    private String s_phone;
    private String s_email;
}
